<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_region`;");
E_C("CREATE TABLE `ecs_region` (
  `region_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `region_name` varchar(120) NOT NULL DEFAULT '',
  `region_type` tinyint(1) NOT NULL DEFAULT '2',
  `agency_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`region_id`),
  KEY `parent_id` (`parent_id`),
  KEY `region_type` (`region_type`),
  KEY `agency_id` (`agency_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3450 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_region` values('1','0','中国','0','0');");
E_D("replace into `ecs_region` values('2','1','北京','1','0');");
E_D("replace into `ecs_region` values('10','1','河北','1','0');");
E_D("replace into `ecs_region` values('52','2','北京','2','0');");
E_D("replace into `ecs_region` values('138','10','石家庄','2','0');");
E_D("replace into `ecs_region` values('145','10','秦皇岛','2','0');");
E_D("replace into `ecs_region` values('500','52','东城区','3','0');");
E_D("replace into `ecs_region` values('3421','502','中关村','4','0');");
E_D("replace into `ecs_region` values('502','52','海淀区','3','0');");
E_D("replace into `ecs_region` values('3424','502','颐和园','4','0');");
E_D("replace into `ecs_region` values('3423','502','紫竹桥','4','0');");
E_D("replace into `ecs_region` values('3422','502','知春路','4','0');");
E_D("replace into `ecs_region` values('3426','500','安定门','4','0');");
E_D("replace into `ecs_region` values('3425','500','南锣鼓巷','4','0');");
E_D("replace into `ecs_region` values('3427','500','雍和宫','4','0');");
E_D("replace into `ecs_region` values('1078','138','长安区','3','0');");
E_D("replace into `ecs_region` values('1079','138','桥东区','3','0');");
E_D("replace into `ecs_region` values('1080','138','桥西区','3','0');");
E_D("replace into `ecs_region` values('1081','138','新华区','3','0');");
E_D("replace into `ecs_region` values('1082','138','裕华区','3','0');");
E_D("replace into `ecs_region` values('1083','138','井陉矿区','3','0');");
E_D("replace into `ecs_region` values('1084','138','高新区','3','0');");
E_D("replace into `ecs_region` values('1085','138','辛集市','3','0');");
E_D("replace into `ecs_region` values('1086','138','藁城市','3','0');");
E_D("replace into `ecs_region` values('1087','138','晋州市','3','0');");
E_D("replace into `ecs_region` values('1088','138','新乐市','3','0');");
E_D("replace into `ecs_region` values('1089','138','鹿泉市','3','0');");
E_D("replace into `ecs_region` values('1090','138','井陉县','3','0');");
E_D("replace into `ecs_region` values('1091','138','正定县','3','0');");
E_D("replace into `ecs_region` values('1092','138','栾城县','3','0');");
E_D("replace into `ecs_region` values('1093','138','行唐县','3','0');");
E_D("replace into `ecs_region` values('1094','138','灵寿县','3','0');");
E_D("replace into `ecs_region` values('1095','138','高邑县','3','0');");
E_D("replace into `ecs_region` values('1097','138','赞皇县','3','0');");
E_D("replace into `ecs_region` values('1098','138','无极县','3','0');");
E_D("replace into `ecs_region` values('3420','1195','老虎石','4','0');");
E_D("replace into `ecs_region` values('3419','1195','草场','4','0');");
E_D("replace into `ecs_region` values('3418','1195','刘庄','4','0');");
E_D("replace into `ecs_region` values('3417','1195','单庄','4','0');");
E_D("replace into `ecs_region` values('3416','1196','船厂','4','0');");
E_D("replace into `ecs_region` values('3415','1196','老龙头','4','0');");
E_D("replace into `ecs_region` values('3414','1196','第二中学','4','0');");
E_D("replace into `ecs_region` values('3413','1196','山海关火车站','4','0');");
E_D("replace into `ecs_region` values('3412','1196','山海关','4','0');");
E_D("replace into `ecs_region` values('3411','1194','东山浴场','4','0');");
E_D("replace into `ecs_region` values('3410','1194','太阳城','4','0');");
E_D("replace into `ecs_region` values('1194','145','海港区','3','0');");
E_D("replace into `ecs_region` values('1195','145','北戴河区','3','0');");
E_D("replace into `ecs_region` values('1196','145','山海关区','3','0');");
E_D("replace into `ecs_region` values('3439','3431','和平区','3','0');");
E_D("replace into `ecs_region` values('3440','3431','皇姑区','3','0');");
E_D("replace into `ecs_region` values('3433','3428','鞍山','2','0');");
E_D("replace into `ecs_region` values('3432','3428','大连','2','0');");
E_D("replace into `ecs_region` values('3431','3428','沈阳','2','0');");
E_D("replace into `ecs_region` values('3428','1','辽宁','1','0');");
E_D("replace into `ecs_region` values('3409','1194','白塔岭','4','0');");

require("../../inc/footer.php");
?>